CREATE TABLE [dbo].[ContentChangeRequest]
(
[ContentChangeRequestKey] [uniqueidentifier] NOT NULL,
[ContentDocumentVersionKey] [uniqueidentifier] NOT NULL,
[ContentRequestStatusCode] [int] NOT NULL,
[AssignedByUserKey] [uniqueidentifier] NOT NULL,
[AssignedToUserKey] [uniqueidentifier] NULL,
[RequestText] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RequestDateTime] [datetime] NOT NULL,
[ReassignedToUserKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContentChangeRequest] ADD CONSTRAINT [PK_ContentChangeRequest] PRIMARY KEY CLUSTERED ([ContentChangeRequestKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContentChangeRequest_AssignedByUserKey] ON [dbo].[ContentChangeRequest] ([AssignedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContentChangeRequest_AssignedToUserKey] ON [dbo].[ContentChangeRequest] ([AssignedToUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContentChangeRequest_ContentDocumentVersionKey] ON [dbo].[ContentChangeRequest] ([ContentDocumentVersionKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContentChangeRequest_ReassignedToUserKey] ON [dbo].[ContentChangeRequest] ([ReassignedToUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContentChangeRequest] ADD CONSTRAINT [FK_ContentChangeRequest_UniformRegistry] FOREIGN KEY ([ContentDocumentVersionKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO
ALTER TABLE [dbo].[ContentChangeRequest] ADD CONSTRAINT [FK_ContentChangeRequest_UserMain_AssignedBy] FOREIGN KEY ([AssignedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[ContentChangeRequest] ADD CONSTRAINT [FK_ContentChangeRequest_UserMain_AssignedTo] FOREIGN KEY ([AssignedToUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[ContentChangeRequest] ADD CONSTRAINT [FK_ContentChangeRequest_UserMain_ReassignedTo] FOREIGN KEY ([ReassignedToUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO